Tabela PerfResource

Definicja tabeli PerfResource

Name

PerfResource

Code

PerfResource

Comment

 


Lista kolumn tabeli PerfResource

Name

Code

PerfResourceID

PerfResourceID

UnitID

UnitID

ApplicationWayID

ApplicationWayID

PerfResourceStatusID

PerfResourceStatusID

ResourceID

ResourceID

EventID

EventID

MedResourceID

MedResourceID

PerfServiceID

PerfServiceID

TherapyTypeID

TherapyTypeID

CostAccountID

CostAccountID

Per_PerfResourceID

Per_PerfResourceID

UnitsCount

UnitsCount

PerNoOfUnits

PerNoOfUnits

PerfOrgUnit

PerfOrgUnit

OrderingOrgUnit

OrderingOrgUnit

PerfPerson

PerfPerson

OrderingPerson

OrderingPerson

PerfDT

PerfDT

OrderDT

OrderDT

Comments

Comments

SeriesNo

SeriesNo

StatCode

StatCode

ContractPrice

ContractPrice

OrderedUnitsCount

OrderedUnitsCount

OrderedResourceID

OrderedResourceID

SysFctID

SysFctID

UnitMultiplier

UnitMultiplier

IsGivenToPatient

IsGivenToPatient

GivenDaysAmount

GivenDaysAmount

StopDT

StopDT

SequenceNo

SequenceNo

Remarks

Remarks

BenefitPlanContractID

BenefitPlanContractID


Kolumna PerfResourceID tabeli PerfResource

Definicja kolumny PerfResourceID tabeli PerfResource

Name

PerfResourceID

Code

PerfResourceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna UnitID tabeli PerfResource

Definicja kolumny UnitID tabeli PerfResource

Name

UnitID

Code

UnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ApplicationWayID tabeli PerfResource

Definicja kolumny ApplicationWayID tabeli PerfResource

Name

ApplicationWayID

Code

ApplicationWayID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfResourceStatusID tabeli PerfResource

Definicja kolumny PerfResourceStatusID tabeli PerfResource

Name

PerfResourceStatusID

Code

PerfResourceStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ResourceID tabeli PerfResource

Definicja kolumny ResourceID tabeli PerfResource

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna EventID tabeli PerfResource

Definicja kolumny EventID tabeli PerfResource

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MedResourceID tabeli PerfResource

Definicja kolumny MedResourceID tabeli PerfResource

Name

MedResourceID

Code

MedResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfServiceID tabeli PerfResource

Definicja kolumny PerfServiceID tabeli PerfResource

Name

PerfServiceID

Code

PerfServiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna TherapyTypeID tabeli PerfResource

Definicja kolumny TherapyTypeID tabeli PerfResource

Name

TherapyTypeID

Code

TherapyTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CostAccountID tabeli PerfResource

Definicja kolumny CostAccountID tabeli PerfResource

Name

CostAccountID

Code

CostAccountID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Per_PerfResourceID tabeli PerfResource

Definicja kolumny Per_PerfResourceID tabeli PerfResource

Name

Per_PerfResourceID

Code

Per_PerfResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UnitsCount tabeli PerfResource

Definicja kolumny UnitsCount tabeli PerfResource

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(13,4)

Mandatory

No

Comment

 


Kolumna PerNoOfUnits tabeli PerfResource

Definicja kolumny PerNoOfUnits tabeli PerfResource

Name

PerNoOfUnits

Code

PerNoOfUnits

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfOrgUnit tabeli PerfResource

Definicja kolumny PerfOrgUnit tabeli PerfResource

Name

PerfOrgUnit

Code

PerfOrgUnit

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrderingOrgUnit tabeli PerfResource

Definicja kolumny OrderingOrgUnit tabeli PerfResource

Name

OrderingOrgUnit

Code

OrderingOrgUnit

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfPerson tabeli PerfResource

Definicja kolumny PerfPerson tabeli PerfResource

Name

PerfPerson

Code

PerfPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrderingPerson tabeli PerfResource

Definicja kolumny OrderingPerson tabeli PerfResource

Name

OrderingPerson

Code

OrderingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfDT tabeli PerfResource

Definicja kolumny PerfDT tabeli PerfResource

Name

PerfDT

Code

PerfDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna OrderDT tabeli PerfResource

Definicja kolumny OrderDT tabeli PerfResource

Name

OrderDT

Code

OrderDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Comments tabeli PerfResource

Definicja kolumny Comments tabeli PerfResource

Name

Comments

Code

Comments

Data Type

VARCHAR2(4000)

Mandatory

No

Comment

 


Kolumna SeriesNo tabeli PerfResource

Definicja kolumny SeriesNo tabeli PerfResource

Name

SeriesNo

Code

SeriesNo

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna StatCode tabeli PerfResource

Definicja kolumny StatCode tabeli PerfResource

Name

StatCode

Code

StatCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna ContractPrice tabeli PerfResource

Definicja kolumny ContractPrice tabeli PerfResource

Name

ContractPrice

Code

ContractPrice

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna OrderedUnitsCount tabeli PerfResource

Definicja kolumny OrderedUnitsCount tabeli PerfResource

Name

OrderedUnitsCount

Code

OrderedUnitsCount

Data Type

NUMBER(12,4)

Mandatory

No

Comment

 


Kolumna OrderedResourceID tabeli PerfResource

Definicja kolumny OrderedResourceID tabeli PerfResource

Name

OrderedResourceID

Code

OrderedResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

Pole bedzie przechowywac informacje o oryginalnie(poczatkowo) zleconym zasobie (np leku).


Kolumna SysFctID tabeli PerfResource

Definicja kolumny SysFctID tabeli PerfResource

Name

SysFctID

Code

SysFctID

Data Type

NUMBER(10)

Mandatory

No

Comment

Informacja w jakim kontekscie (funkcja systemowa)
zostalo odnotowane wykonanie zuzycie zasobu.


Kolumna UnitMultiplier tabeli PerfResource

Definicja kolumny UnitMultiplier tabeli PerfResource

Name

UnitMultiplier

Code

UnitMultiplier

Data Type

NUMBER(12,6)

Mandatory

No

Comment

Przelicznik wartosci z kolumny PerfResource.UnitsCount w jednostce PerfResource.UnitID na opakowanie magazynowe danego zasobu


Kolumna IsGivenToPatient tabeli PerfResource

Definicja kolumny IsGivenToPatient tabeli PerfResource

Name

IsGivenToPatient

Code

IsGivenToPatient

Data Type

NUMBER(5)

Mandatory

No

Comment

Flaga mówiaca o wydaniu pacjentowi leku do domu


Kolumna GivenDaysAmount tabeli PerfResource

Definicja kolumny GivenDaysAmount tabeli PerfResource

Name

GivenDaysAmount

Code

GivenDaysAmount

Data Type

NUMBER(10)

Mandatory

No

Comment

Informuje na ile dni lek zostal wydany pacjentowi do domu


Kolumna StopDT tabeli PerfResource

Definicja kolumny StopDT tabeli PerfResource

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Data konca przetoczenia krwi


Kolumna SequenceNo tabeli PerfResource

Definicja kolumny SequenceNo tabeli PerfResource

Name

SequenceNo

Code

SequenceNo

Data Type

NUMBER(10)

Mandatory

No

Comment

Kolejny numer dla PerfResource w obrebie danego PerfService'a. Numer donacji dla transfuzji.


Kolumna Remarks tabeli PerfResource

Definicja kolumny Remarks tabeli PerfResource

Name

Remarks

Code

Remarks

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Dodatkowe informacje o zuzytym produkcie/wyrobie med. np: informacje o paszporcie wyrobów implantowych


Kolumna BenefitPlanContractID tabeli PerfResource

Definicja kolumny BenefitPlanContractID tabeli PerfResource

Name

BenefitPlanContractID

Code

BenefitPlanContractID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli PerfResource

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PerfResource

Definicja klucza Identifier_1 tabeli PerfResource

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment